Are string comparisons in postgresql case sensitive?
I keep on having this response:
SELECT *
FROM People
WHERE first_name='jordan'
Result: 0 records
SELECT *
FROM People
WHERE first_name='Jordan'
Result: 1 record
I though that string matching in SQL was case-insensitive. Isn't this correct? If not, what workarounds have been used
successfullybefore? Obviously, formatting the search string for the query is not a solution...
--
Jordan Reiter mailto:jordan@breezing.com
Breezing.com http://breezing.com
1106 West Main St phone:434.295.2050
Charlottesville, VA 22903 fax:603.843.6931